ProductServices.php#323laravel_shop22.48msSELECT product_id, MIN(`price` / `num`) as min FROM product_packaging WHERE is_showed =1AND price !=0GROUPBY product_id
ProductServices.php#324laravel_shop62.67msSELECT pp.product_id, pd.dosage, MAX(pp.num) AS max_num, MIN(pp.num) AS min_num, MIN(pp.price) as min_price, MAX(pp.price) as max_price
FROM product_dosage pd
JOIN product_packaging pp ON pd.product_id = pp.product_id AND pd.dosage = pp.dosage
WHERE pp.is_showed =1AND pp.price !=0GROUPBY pp.product_id, pd.dosage
ORDERBY pp.product_id;
ProductServices.php#323laravel_shop17.89msSELECT product_id, MIN(`price` / `num`) as min FROM product_packaging WHERE is_showed =1AND price !=0GROUPBY product_id
ProductServices.php#324laravel_shop62msSELECT pp.product_id, pd.dosage, MAX(pp.num) AS max_num, MIN(pp.num) AS min_num, MIN(pp.price) as min_price, MAX(pp.price) as max_price
FROM product_dosage pd
JOIN product_packaging pp ON pd.product_id = pp.product_id AND pd.dosage = pp.dosage
WHERE pp.is_showed =1AND pp.price !=0GROUPBY pp.product_id, pd.dosage
ORDERBY pp.product_id;
ProductServices.php#323laravel_shop21.58msSELECT product_id, MIN(`price` / `num`) as min FROM product_packaging WHERE is_showed =1AND price !=0GROUPBY product_id
ProductServices.php#324laravel_shop63.46msSELECT pp.product_id, pd.dosage, MAX(pp.num) AS max_num, MIN(pp.num) AS min_num, MIN(pp.price) as min_price, MAX(pp.price) as max_price
FROM product_dosage pd
JOIN product_packaging pp ON pd.product_id = pp.product_id AND pd.dosage = pp.dosage
WHERE pp.is_showed =1AND pp.price !=0GROUPBY pp.product_id, pd.dosage
ORDERBY pp.product_id;
ProductServices.php#139laravel_shop930μsselect `product`.*, `product_category`.`category_id` as `pivot_category_id`, `product_category`.`product_id` as `pivot_product_id` from `product` innerjoin `product_category` on `product`.`id` = `product_category`.`product_id` where `product_category`.`category_id` in (23)